Diagram Archive

Defincja diagramu Archive

Name

Archive

Code

Archive

Comment

 


Lista tabel diagramu

Name

Code

ADOrderItemGroup

ADOrderItemGroup

ADOrderItemGroupType

ADOrderItemGroupType

Archive

Archive

ARCHIVECOPYORDER

ARCHIVECOPYORDER

ArchiveDoc

ArchiveDoc

ArchiveDocLoc

ArchiveDocLoc

ArchiveDocLocText

ArchiveDocLocText

ArchiveDocOperation

ArchiveDocOperation

ArchiveDocOperationType

ArchiveDocOperationType

ArchiveDocOperationTypeText

ArchiveDocOperationTypeText

ArchiveDocOrder

ArchiveDocOrder

ArchiveDocOrderItem

ArchiveDocOrderItem

ArchiveDocOrderPriority

ArchiveDocOrderPriority

ArchiveDocOrderPriorityText

ArchiveDocOrderPriorityText

ArchiveDocState

ArchiveDocState

ArchiveDocStateText

ArchiveDocStateText

ArchiveDocStatus

ArchiveDocStatus

ArchiveDocStatusText

ArchiveDocStatusText

ArchiveDocStorageTime

ArchiveDocStorageTime

ArchiveDocStorageTimeText

ArchiveDocStorageTimeText

ArchiveDocType

ArchiveDocType

ArchiveDocTypePrefix

ArchiveDocTypePrefix

ArchiveDocTypePrefixText

ArchiveDocTypePrefixText

ArchiveDocTypeSuffix

ArchiveDocTypeSuffix

ArchiveDocTypeSuffixText

ArchiveDocTypeSuffixText

ArchiveDocTypeText

ArchiveDocTypeText

ArchiveText

ArchiveText

DictionaryValue

DictionaryValue

Episode

Episode

Event

Event

ExternalIdentifier

ExternalIdentifier

IdentifierType

IdentifierType

InstitutionType

InstitutionType

InstitutionTypeText

InstitutionTypeText

LADOrderItemGroup

LADOrderItemGroup

OrderingSubjectType

OrderingSubjectType

OrderingSubjectTypeText

OrderingSubjectTypeText

OrderPurpose

OrderPurpose

OrderPurposeText

OrderPurposeText

Patient

Patient

Person

Person

Reservation

Reservation


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_343

R_343

Patient

Episode

PersonID

 

 

R_6040

R_6040

ArchiveDocType

ArchiveDocType

Arc_ArchiveDocTypeID

 

 

R_6041

R_6041

IdentifierType

ArchiveDocType

IdentifierTypeID

 

 

R_6042

R_6042

ArchiveDocType

ArchiveDocTypeText

ArchiveDocTypeID

 

 

R_6043

R_6043

ArchiveDoc

ArchiveDoc

Arc_ArchiveDocID

 

 

R_6044

R_6044

ArchiveDocType

ArchiveDoc

ArchiveDocTypeID

 

 

R_6045

R_6045

ExternalIdentifier

ArchiveDoc

IdentifierTypeID; ExternalValue

 

 

R_6046

R_6046

Episode

ArchiveDoc

EpisodeID

 

 

R_6047

R_6047

Patient

ArchiveDoc

PersonID

 

 

R_6048

R_6048

ArchiveDocState

ArchiveDoc

ArchiveDocStateID

 

 

R_6050

R_6050

ArchiveDocState

ArchiveDocStateText

ArchiveDocStateID

 

 

R_6051

R_6051

ArchiveDocOperationType

ArchiveDocOperationTypeText

ArchiveDocOperationTypeID

 

 

R_6052

R_6052

ArchiveDocOperationType

ArchiveDocOperation

ArchiveDocOperationTypeID

 

 

R_6054

R_6054

ArchiveDoc

ArchiveDocOperation

ArchiveDocID

 

 

R_6056

R_6056

ArchiveDocType

ArchiveDocTypePrefix

ArchiveDocTypeID

 

 

R_6057

R_6057

ArchiveDocTypePrefix

ArchiveDocTypePrefixText

ArchiveDocTypePrefixID

 

 

R_6058

R_6058

ArchiveDocOrderPriority

ArchiveDocOrderPriorityText

ArchiveDocOrderPriorityID

 

 

R_6059

R_6059

OrderingSubjectType

OrderingSubjectTypeText

OrderingSubjectTypeID

 

 

R_6060

R_6060

InstitutionType

InstitutionTypeText

InstitutionTypeID

 

 

R_6061

R_6061

ArchiveDocOrderPriority

ArchiveDocOrder

ArchiveDocOrderPriorityID

 

 

R_6062

R_6062

OrderingSubjectType

ArchiveDocOrder

OrderingSubjectTypeID

 

 

R_6063

R_6063

Person

ArchiveDocOrder

PersonID

 

 

R_6065

R_6065

InstitutionType

ArchiveDocOrder

InstitutionTypeID

 

 

R_6066

R_6066

ArchiveDocStatus

ArchiveDocStatusText

ArchiveDocStatusID

 

 

R_6067

R_6067

OrderPurpose

OrderPurposeText

OrderPurposeID

 

 

R_6068

R_6068

ArchiveDoc

ArchiveDocOrderItem

ArchiveDocID

 

 

R_6069

R_6069

ArchiveDocOrder

ArchiveDocOrderItem

ArchiveDocOrderID

 

 

R_6070

R_6070

ArchiveDocStatus

ArchiveDocOrderItem

ArchiveDocStatusID

 

 

R_6071

R_6071

OrderPurpose

ArchiveDocOrderItem

OrderPurposeID

 

 

R_6074

R_6074

ArchiveDocOrderItem

ArchiveDocOperation

ArchiveDocOrderItemID

 

 

R_7041

R_7041

Archive

ArchiveText

ArchiveID

 

 

R_7042

R_7042

Archive

ArchiveDoc

ArchiveID

 

 

R_8979

R_8979

ArchiveDocStorageTime

ArchiveDocStorageTimeText

ArchiveDocStorageTimeID

 

 

R_8980

R_8980

ArchiveDocStorageTime

ArchiveDoc

ArchiveDocStorageTimeID

 

 

R_9099

R_9099

ArchiveDocLoc

ArchiveDocLocText

ArchiveDocLocID

 

 

R_9100

R_9100

ArchiveDocLoc

ArchiveDoc

ArchiveDocLocID

 

 

R_9261

R_9261

Reservation

ArchiveDocOrder

ReservationID

 

 

R_9262

R_9262

Episode

ArchiveDocOrder

EpisodeID

 

 

R_9263

R_9263

Event

ArchiveDocOrder

EventID

 

 

R_9843

R_9843

ArchiveDocType

ArchiveDocTypeSuffix

ArchiveDocTypeID

 

 

R_9844

R_9844

ArchiveDocTypeSuffix

ArchiveDocTypeSuffixText

ArchiveDocTypeSuffixID

 

 

R_9845

R_9845

IdentifierType

ADOrderItemGroupType

IdentifierTypeID

 

 

R_9846

R_9846

ADOrderItemGroupType

ADOrderItemGroup

ADOrderItemGroupTypeID

 

 

R_9847

R_9847

ADOrderItemGroup

LADOrderItemGroup

ADOrderItemGroupID

 

 

R_9848

R_9848

ArchiveDocOrderItem

LADOrderItemGroup

ArchiveDocOrderItemID

 

 

R_9849

R_9849

ArchiveDocStatus

ArchiveDocOrderItem

ArchiveDocRealizationStatusID

 

 

R_9850

R_9850

ArchiveDocLoc

ArchiveDocOrderItem

LendLocID

 

 

R_9886

R_9886

ArchiveDocLoc

ArchiveDoc

CreateLocID

 

 

R_9891

R_9891

ADOrderItemGroup

ArchiveDocOperation

ADOrderItemGroupID

 

 

R_9911

R_9911

DictionaryValue

ArchiveDoc

ArchiveCategoryID